package com.hospital.demo.mapper.gaoyuran;

import com.hospital.demo.model.gaoyuran.EquAndExp;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface EquAndExpMapper {

    //查看全部器材使用信息
    @Select("select eid,equipment.meid,equipment.mename,pid,pname,did,dname,meuse,metype from equipment,experiment where equipment.meid=experiment.meid")
    List<EquAndExp> findAll();
}
